CDate

Basic and Crystal syntax.

The DateValue and Date functions are equivalent to CDate. However, Date can only be used in Crystal syntax since it is a type name in Basic syntax.

Overloads
Arguments

CDate (number)

Number is a value representing the number of days starting from December 30, 1899. It can be positive or negative, and is truncated if fractional.

CDate (string)

string is a text string representing a date, example: "September 20, 1999"; many formats are supported for the string

CDate (dateTime)

dateTime is a DateTime value.

CDate (YY,MM,DD)

  • year is a whole number representing a year, example: 1996.
  • month is a whole number representing a month, example: 12 for December.
  • day is a whole number representing a day of the month, example: 05.

Returns

Date value

Action

CDate (number) converts and returns a Date given a number which is the number of days starting from December 30, 1899.

CDate (string) converts and returns a Date given a string.

CDate (dateTime) converts and returns a Date given a DateTime value.

CDate (YYYY, MM, DD) uses the given arguments to create a Date value.

Examples

The following examples are applicable to both Basic and Crystal syntax:

CDate ("Dec. 31, 1999")

Returns the Date value for Dec. 31, 1999.

CDate (50)

Returns the Date value for February 18, 1900.

CDate (#Oct. 20, 1999 12:02pm#)

Returns the Date value for October 20, 1999.

CDate (1930, 7, 30)

Returns the Date value for July 30, 1930.

Comments

You can use the IsDate function to check if a String argument can be converted to a Date before doing the actual conversion. That way, if the conversion cannot be done, you can handle the situation appropriately.

Related topics

DateSerial (year, month, day)



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com